CREATE TABLE [dbo].[RelationshipMain]
(
[RelationshipKey] [uniqueidentifier] NOT NULL,
[RelationshipTypeKey] [uniqueidentifier] NOT NULL,
[SubjectUniformKey] [uniqueidentifier] NOT NULL,
[TargetUniformKey] [uniqueidentifier] NOT NULL,
[EffectiveDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[RelationshipMain] ADD CONSTRAINT [PK_RelationshipMain] PRIMARY KEY CLUSTERED ([RelationshipKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Relationship_SubjectUniformKey] ON [dbo].[RelationshipMain] ([SubjectUniformKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Relationship_TargetUniformKey] ON [dbo].[RelationshipMain] ([TargetUniformKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RelationshipMain] ADD CONSTRAINT [FK_Relationship_RelationshipTypeRef] FOREIGN KEY ([RelationshipTypeKey]) REFERENCES [dbo].[RelationshipTypeRef] ([RelationshipTypeKey])
GO
ALTER TABLE [dbo].[RelationshipMain] ADD CONSTRAINT [FK_RelationshipMain_UniformRegistry_Subject] FOREIGN KEY ([SubjectUniformKey]) REFERENCES [dbo].[UniformRegistry] ([UniformKey])
GO
ALTER TABLE [dbo].[RelationshipMain] ADD CONSTRAINT [FK_RelationshipMain_UniformRegistry_Target] FOREIGN KEY ([TargetUniformKey]) REFERENCES [dbo].[UniformRegistry] ([UniformKey])
GO